<?php


use Phinx\Seed\AbstractSeed;

class CategorySeeder extends AbstractSeed
{
    /**
     * Run Method.
     *
     * Write your database seeder using this method.
     *
     * More information on writing seeders is available here:
     * https://book.cakephp.org/phinx/0/en/seeding.html
     */
    public function run()
    {
        $this->table('kg_category')->truncate();

        $query = $this->getInsertQuery();

        $this->execute($query);
    }

    protected function getInsertQuery():string
    {
        return <<<MYSQL
INSERT INTO `kg_category` (`id`, `parent_id`, `level`, `type`, `name`, `path`, `priority`, `published`, `deleted`, `child_count`, `create_time`, `update_time`) VALUES (1, 0, 1, 1, '前端开发', ',1,', 1, 1, 0, 12, 1524709027, 1595877422);
INSERT INTO `kg_category` (`id`, `parent_id`, `level`, `type`, `name`, `path`, `priority`, `published`, `deleted`, `child_count`, `create_time`, `update_time`) VALUES (2, 0, 1, 1, '后端开发', ',2,', 2, 1, 0, 8, 1524709027, 1618035462);
INSERT INTO `kg_category` (`id`, `parent_id`, `level`, `type`, `name`, `path`, `priority`, `published`, `deleted`, `child_count`, `create_time`, `update_time`) VALUES (3, 0, 1, 1, '移动开发', ',3,', 3, 1, 0, 4, 1524708947, 1595877422);
INSERT INTO `kg_category` (`id`, `parent_id`, `level`, `type`, `name`, `path`, `priority`, `published`, `deleted`, `child_count`, `create_time`, `update_time`) VALUES (4, 0, 1, 1, '数据库', ',4,', 4, 1, 0, 5, 1524709027, 1595877422);
INSERT INTO `kg_category` (`id`, `parent_id`, `level`, `type`, `name`, `path`, `priority`, `published`, `deleted`, `child_count`, `create_time`, `update_time`) VALUES (5, 0, 1, 1, '计算机基础', ',5,', 5, 1, 0, 3, 1524709081, 1595877422);
INSERT INTO `kg_category` (`id`, `parent_id`, `level`, `type`, `name`, `path`, `priority`, `published`, `deleted`, `child_count`, `create_time`, `update_time`) VALUES (6, 0, 1, 1, '前沿技术', ',6,', 6, 1, 0, 8, 1524970572, 1595877422);
INSERT INTO `kg_category` (`id`, `parent_id`, `level`, `type`, `name`, `path`, `priority`, `published`, `deleted`, `child_count`, `create_time`, `update_time`) VALUES (9, 0, 1, 1, '运维&测试', ',9,', 7, 1, 0, 2, 1526658551, 1595877422);
INSERT INTO `kg_category` (`id`, `parent_id`, `level`, `type`, `name`, `path`, `priority`, `published`, `deleted`, `child_count`, `create_time`, `update_time`) VALUES (10, 0, 1, 1, 'UI设计', ',10,', 8, 1, 0, 3, 1526658575, 1597115214);
INSERT INTO `kg_category` (`id`, `parent_id`, `level`, `type`, `name`, `path`, `priority`, `published`, `deleted`, `child_count`, `create_time`, `update_time`) VALUES (11, 1, 2, 1, 'HTML/CSS', ',1,11,', 1, 1, 0, 0, 1526659757, 1595877421);
INSERT INTO `kg_category` (`id`, `parent_id`, `level`, `type`, `name`, `path`, `priority`, `published`, `deleted`, `child_count`, `create_time`, `update_time`) VALUES (12, 1, 2, 1, 'JavaScript', ',1,12,', 2, 1, 0, 0, 1526659809, 1595877421);
INSERT INTO `kg_category` (`id`, `parent_id`, `level`, `type`, `name`, `path`, `priority`, `published`, `deleted`, `child_count`, `create_time`, `update_time`) VALUES (13, 1, 2, 1, '小程序', ',1,13,', 14, 1, 0, 0, 1526659851, 1595877421);
INSERT INTO `kg_category` (`id`, `parent_id`, `level`, `type`, `name`, `path`, `priority`, `published`, `deleted`, `child_count`, `create_time`, `update_time`) VALUES (14, 6, 2, 1, '自然语言处理', ',6,14,', 8, 1, 0, 0, 1526659872, 1595877421);
INSERT INTO `kg_category` (`id`, `parent_id`, `level`, `type`, `name`, `path`, `priority`, `published`, `deleted`, `child_count`, `create_time`, `update_time`) VALUES (15, 1, 2, 1, 'jQuery', ',1,15,', 7, 1, 0, 0, 1526659904, 1595877421);
INSERT INTO `kg_category` (`id`, `parent_id`, `level`, `type`, `name`, `path`, `priority`, `published`, `deleted`, `child_count`, `create_time`, `update_time`) VALUES (16, 1, 2, 1, 'Node.js', ',1,16,', 3, 1, 0, 0, 1526659922, 1595877421);
INSERT INTO `kg_category` (`id`, `parent_id`, `level`, `type`, `name`, `path`, `priority`, `published`, `deleted`, `child_count`, `create_time`, `update_time`) VALUES (17, 1, 2, 1, 'Bootstrap', ',1,17,', 8, 1, 0, 0, 1526659943, 1595877421);
INSERT INTO `kg_category` (`id`, `parent_id`, `level`, `type`, `name`, `path`, `priority`, `published`, `deleted`, `child_count`, `create_time`, `update_time`) VALUES (18, 1, 2, 1, 'Angular', ',1,18,', 6, 1, 0, 0, 1526659972, 1595877421);
INSERT INTO `kg_category` (`id`, `parent_id`, `level`, `type`, `name`, `path`, `priority`, `published`, `deleted`, `child_count`, `create_time`, `update_time`) VALUES (19, 1, 2, 1, 'React.js', ',1,19,', 5, 1, 0, 0, 1526660010, 1595877421);
INSERT INTO `kg_category` (`id`, `parent_id`, `level`, `type`, `name`, `path`, `priority`, `published`, `deleted`, `child_count`, `create_time`, `update_time`) VALUES (20, 1, 2, 1, 'Vue.js', ',1,20,', 4, 1, 0, 0, 1526660039, 1595877421);
INSERT INTO `kg_category` (`id`, `parent_id`, `level`, `type`, `name`, `path`, `priority`, `published`, `deleted`, `child_count`, `create_time`, `update_time`) VALUES (21, 1, 2, 1, 'Sass/Less', ',1,21,', 11, 1, 0, 0, 1526660079, 1595877421);
INSERT INTO `kg_category` (`id`, `parent_id`, `level`, `type`, `name`, `path`, `priority`, `published`, `deleted`, `child_count`, `create_time`, `update_time`) VALUES (22, 1, 2, 1, 'WebApp', ',1,22,', 12, 1, 0, 0, 1526660104, 1595877421);
INSERT INTO `kg_category` (`id`, `parent_id`, `level`, `type`, `name`, `path`, `priority`, `published`, `deleted`, `child_count`, `create_time`, `update_time`) VALUES (23, 1, 2, 1, '前端工具', ',1,23,', 13, 1, 0, 0, 1526660156, 1595877421);
INSERT INTO `kg_category` (`id`, `parent_id`, `level`, `type`, `name`, `path`, `priority`, `published`, `deleted`, `child_count`, `create_time`, `update_time`) VALUES (24, 2, 2, 1, 'PHP', ',2,24,', 1, 1, 0, 0, 1526661620, 1595877421);
INSERT INTO `kg_category` (`id`, `parent_id`, `level`, `type`, `name`, `path`, `priority`, `published`, `deleted`, `child_count`, `create_time`, `update_time`) VALUES (25, 2, 2, 1, 'Java', ',2,25,', 2, 1, 0, 0, 1526661726, 1595877421);
INSERT INTO `kg_category` (`id`, `parent_id`, `level`, `type`, `name`, `path`, `priority`, `published`, `deleted`, `child_count`, `create_time`, `update_time`) VALUES (26, 2, 2, 1, 'Python', ',2,26,', 3, 1, 0, 0, 1526661839, 1595877421);
INSERT INTO `kg_category` (`id`, `parent_id`, `level`, `type`, `name`, `path`, `priority`, `published`, `deleted`, `child_count`, `create_time`, `update_time`) VALUES (27, 2, 2, 1, 'C', ',2,27,', 4, 1, 0, 0, 1526662012, 1595877421);
INSERT INTO `kg_category` (`id`, `parent_id`, `level`, `type`, `name`, `path`, `priority`, `published`, `deleted`, `child_count`, `create_time`, `update_time`) VALUES (28, 2, 2, 1, 'C++', ',2,28,', 5, 1, 0, 0, 1526662049, 1595877421);
INSERT INTO `kg_category` (`id`, `parent_id`, `level`, `type`, `name`, `path`, `priority`, `published`, `deleted`, `child_count`, `create_time`, `update_time`) VALUES (29, 2, 2, 1, 'Ruby', ',2,29,', 6, 1, 0, 0, 1526662069, 1595877421);
INSERT INTO `kg_category` (`id`, `parent_id`, `level`, `type`, `name`, `path`, `priority`, `published`, `deleted`, `child_count`, `create_time`, `update_time`) VALUES (30, 2, 2, 1, 'Go', ',2,30,', 7, 1, 0, 0, 1526662084, 1595877421);
INSERT INTO `kg_category` (`id`, `parent_id`, `level`, `type`, `name`, `path`, `priority`, `published`, `deleted`, `child_count`, `create_time`, `update_time`) VALUES (31, 2, 2, 1, 'C#', ',2,31,', 8, 1, 0, 0, 1526662108, 1595877421);
INSERT INTO `kg_category` (`id`, `parent_id`, `level`, `type`, `name`, `path`, `priority`, `published`, `deleted`, `child_count`, `create_time`, `update_time`) VALUES (32, 3, 2, 1, 'Android', ',3,32,', 1, 1, 0, 0, 1526662721, 1595877421);
INSERT INTO `kg_category` (`id`, `parent_id`, `level`, `type`, `name`, `path`, `priority`, `published`, `deleted`, `child_count`, `create_time`, `update_time`) VALUES (33, 3, 2, 1, 'IOS', ',3,33,', 2, 1, 0, 0, 1526662735, 1595877421);
INSERT INTO `kg_category` (`id`, `parent_id`, `level`, `type`, `name`, `path`, `priority`, `published`, `deleted`, `child_count`, `create_time`, `update_time`) VALUES (34, 3, 2, 1, 'Unity 3D', ',3,34,', 3, 1, 0, 0, 1526662768, 1595877421);
INSERT INTO `kg_category` (`id`, `parent_id`, `level`, `type`, `name`, `path`, `priority`, `published`, `deleted`, `child_count`, `create_time`, `update_time`) VALUES (35, 3, 2, 1, 'Cocos2d-x', ',3,35,', 4, 1, 0, 0, 1526662793, 1595877421);
INSERT INTO `kg_category` (`id`, `parent_id`, `level`, `type`, `name`, `path`, `priority`, `published`, `deleted`, `child_count`, `create_time`, `update_time`) VALUES (36, 4, 2, 1, 'MySQL', ',4,36,', 1, 1, 0, 0, 1526682900, 1595877421);
INSERT INTO `kg_category` (`id`, `parent_id`, `level`, `type`, `name`, `path`, `priority`, `published`, `deleted`, `child_count`, `create_time`, `update_time`) VALUES (37, 4, 2, 1, 'MongoDB', ',4,37,', 2, 1, 0, 0, 1526682925, 1595877421);
INSERT INTO `kg_category` (`id`, `parent_id`, `level`, `type`, `name`, `path`, `priority`, `published`, `deleted`, `child_count`, `create_time`, `update_time`) VALUES (38, 4, 2, 1, 'Redis', ',4,38,', 3, 1, 0, 0, 1526682978, 1595877421);
INSERT INTO `kg_category` (`id`, `parent_id`, `level`, `type`, `name`, `path`, `priority`, `published`, `deleted`, `child_count`, `create_time`, `update_time`) VALUES (39, 4, 2, 1, 'Oracle', ',4,39,', 4, 1, 0, 0, 1526682997, 1595877421);
INSERT INTO `kg_category` (`id`, `parent_id`, `level`, `type`, `name`, `path`, `priority`, `published`, `deleted`, `child_count`, `create_time`, `update_time`) VALUES (40, 6, 2, 1, '机器学习', ',6,40,', 5, 1, 0, 0, 1526683196, 1595877421);
INSERT INTO `kg_category` (`id`, `parent_id`, `level`, `type`, `name`, `path`, `priority`, `published`, `deleted`, `child_count`, `create_time`, `update_time`) VALUES (41, 6, 2, 1, '深度学习', ',6,41,', 6, 1, 0, 0, 1526683250, 1595877421);
INSERT INTO `kg_category` (`id`, `parent_id`, `level`, `type`, `name`, `path`, `priority`, `published`, `deleted`, `child_count`, `create_time`, `update_time`) VALUES (42, 6, 2, 1, '云计算', ',6,42,', 1, 1, 0, 0, 1526683337, 1595877421);
INSERT INTO `kg_category` (`id`, `parent_id`, `level`, `type`, `name`, `path`, `priority`, `published`, `deleted`, `child_count`, `create_time`, `update_time`) VALUES (43, 6, 2, 1, '大数据', ',6,43,', 2, 1, 0, 0, 1526683395, 1595877421);
INSERT INTO `kg_category` (`id`, `parent_id`, `level`, `type`, `name`, `path`, `priority`, `published`, `deleted`, `child_count`, `create_time`, `update_time`) VALUES (44, 9, 2, 1, '测试', ',9,44,', 1, 1, 0, 0, 1526683451, 1595877421);
INSERT INTO `kg_category` (`id`, `parent_id`, `level`, `type`, `name`, `path`, `priority`, `published`, `deleted`, `child_count`, `create_time`, `update_time`) VALUES (45, 9, 2, 1, '运维', ',9,45,', 2, 1, 0, 0, 1526683465, 1595877421);
INSERT INTO `kg_category` (`id`, `parent_id`, `level`, `type`, `name`, `path`, `priority`, `published`, `deleted`, `child_count`, `create_time`, `update_time`) VALUES (46, 10, 2, 1, '动画特效', ',10,46,', 1, 1, 0, 0, 1526683577, 1595877421);
INSERT INTO `kg_category` (`id`, `parent_id`, `level`, `type`, `name`, `path`, `priority`, `published`, `deleted`, `child_count`, `create_time`, `update_time`) VALUES (47, 10, 2, 1, '设计工具', ',10,47,', 2, 1, 0, 0, 1526683637, 1595877421);
INSERT INTO `kg_category` (`id`, `parent_id`, `level`, `type`, `name`, `path`, `priority`, `published`, `deleted`, `child_count`, `create_time`, `update_time`) VALUES (48, 10, 2, 1, '设计基础', ',10,48,', 3, 1, 0, 0, 1526683662, 1595877421);
INSERT INTO `kg_category` (`id`, `parent_id`, `level`, `type`, `name`, `path`, `priority`, `published`, `deleted`, `child_count`, `create_time`, `update_time`) VALUES (49, 4, 2, 1, 'PostgreSQL', ',4,49,', 5, 1, 0, 0, 1546790592, 1595877421);
INSERT INTO `kg_category` (`id`, `parent_id`, `level`, `type`, `name`, `path`, `priority`, `published`, `deleted`, `child_count`, `create_time`, `update_time`) VALUES (50, 6, 2, 1, '微服务', ',6,50,', 3, 1, 0, 0, 1580012316, 1595877421);
INSERT INTO `kg_category` (`id`, `parent_id`, `level`, `type`, `name`, `path`, `priority`, `published`, `deleted`, `child_count`, `create_time`, `update_time`) VALUES (59, 6, 2, 1, '数据分析', ',6,59,', 7, 1, 0, 0, 1580023776, 1595877421);
INSERT INTO `kg_category` (`id`, `parent_id`, `level`, `type`, `name`, `path`, `priority`, `published`, `deleted`, `child_count`, `create_time`, `update_time`) VALUES (60, 6, 2, 1, '区块链', ',6,60,', 4, 1, 0, 0, 1580024506, 1595877421);
INSERT INTO `kg_category` (`id`, `parent_id`, `level`, `type`, `name`, `path`, `priority`, `published`, `deleted`, `child_count`, `create_time`, `update_time`) VALUES (61, 5, 2, 1, '网络', ',5,61,', 1, 1, 0, 0, 1580026054, 1595877421);
INSERT INTO `kg_category` (`id`, `parent_id`, `level`, `type`, `name`, `path`, `priority`, `published`, `deleted`, `child_count`, `create_time`, `update_time`) VALUES (62, 5, 2, 1, '算法', ',5,62,', 2, 1, 0, 0, 1580026064, 1595877421);
INSERT INTO `kg_category` (`id`, `parent_id`, `level`, `type`, `name`, `path`, `priority`, `published`, `deleted`, `child_count`, `create_time`, `update_time`) VALUES (63, 5, 2, 1, '数学', ',5,63,', 3, 1, 0, 0, 1580026078, 1595877421);
INSERT INTO `kg_category` (`id`, `parent_id`, `level`, `type`, `name`, `path`, `priority`, `published`, `deleted`, `child_count`, `create_time`, `update_time`) VALUES (64, 0, 1, 2, '常见问题', ',64,', 1, 1, 0, 0, 1597115617, 1608455103);
INSERT INTO `kg_category` (`id`, `parent_id`, `level`, `type`, `name`, `path`, `priority`, `published`, `deleted`, `child_count`, `create_time`, `update_time`) VALUES (65, 0, 1, 2, '新手指南', ',65,', 2, 1, 0, 0, 1597127005, 1597128090);
INSERT INTO `kg_category` (`id`, `parent_id`, `level`, `type`, `name`, `path`, `priority`, `published`, `deleted`, `child_count`, `create_time`, `update_time`) VALUES (68, 0, 1, 3, '前端开发', ',68,', 10, 1, 0, 0, 1617243776, 1617243776);
INSERT INTO `kg_category` (`id`, `parent_id`, `level`, `type`, `name`, `path`, `priority`, `published`, `deleted`, `child_count`, `create_time`, `update_time`) VALUES (69, 0, 1, 3, '后端开发', ',69,', 10, 1, 0, 0, 1617243789, 1617243789);
INSERT INTO `kg_category` (`id`, `parent_id`, `level`, `type`, `name`, `path`, `priority`, `published`, `deleted`, `child_count`, `create_time`, `update_time`) VALUES (70, 0, 1, 3, '移动开发', ',70,', 10, 1, 0, 0, 1617243810, 1617243810);
INSERT INTO `kg_category` (`id`, `parent_id`, `level`, `type`, `name`, `path`, `priority`, `published`, `deleted`, `child_count`, `create_time`, `update_time`) VALUES (71, 0, 1, 3, '计算机基础', ',71,', 10, 1, 0, 0, 1617243872, 1617243872);
INSERT INTO `kg_category` (`id`, `parent_id`, `level`, `type`, `name`, `path`, `priority`, `published`, `deleted`, `child_count`, `create_time`, `update_time`) VALUES (72, 0, 1, 3, '前沿技术', ',72,', 10, 1, 0, 0, 1617243887, 1617243887);
INSERT INTO `kg_category` (`id`, `parent_id`, `level`, `type`, `name`, `path`, `priority`, `published`, `deleted`, `child_count`, `create_time`, `update_time`) VALUES (73, 0, 1, 3, '数据库', ',73,', 10, 1, 0, 0, 1617243910, 1617243910);
INSERT INTO `kg_category` (`id`, `parent_id`, `level`, `type`, `name`, `path`, `priority`, `published`, `deleted`, `child_count`, `create_time`, `update_time`) VALUES (74, 0, 1, 3, '运维＆测试', ',74,', 10, 1, 0, 0, 1617243934, 1617243934);
MYSQL;

    }
}
